﻿CREATE TABLE [dbo].[Judete] (
    [IDJudet]         INT          IDENTITY (1, 1) NOT NULL,
    [Nume]            VARCHAR (50) NULL,
    [Sigla]           CHAR (2)     NULL,
    [PrefixTelefonic] VARCHAR (5)  NULL,
    [ResedintaJudet]  VARCHAR (20) NULL,
    [IDTara]          INT          NULL,
    CONSTRAINT [PK_JUDETE_1__13] PRIMARY KEY CLUSTERED ([IDJudet] ASC) WITH (FILLFACTOR = 90),
    CONSTRAINT [FK_Judete_Tari] FOREIGN KEY ([IDTara]) REFERENCES [dbo].[Tari] ([IDTara])
);


GO
CREATE NONCLUSTERED INDEX [IX_Judete_Resedinta]
    ON [dbo].[Judete]([ResedintaJudet] ASC);


GO
CREATE NONCLUSTERED INDEX [IX_Judete_Nume]
    ON [dbo].[Judete]([Nume] ASC);

